package com.ruoyi.project.stop.mapper;


import com.ruoyi.common.mqtts.MqttServerEntity;
import org.apache.ibatis.annotations.Select;

import java.util.List;


/**
 * MQTT服务器Mapper接口
 *
 * @author ruoyi
 * @date 2023-07-04
 */
public interface MqttServerMapper {

    String sqlInfo = "<script> SELECT id, server_host serverHost, server_port serverPort, username, password, client_id clientId, " +
            "client_topic clientTopic, client_clean_session clientCleanSession   from tbl_mqtt_server_dat where is_deleted = 0 ";
    @Select(sqlInfo + "</script>")
    public List<MqttServerEntity> selectMqttAll();

}
